I nneed a function in cell H11 that looks up the sales rep region based on the table in cells...

vhalwwtza


I nneed a function in cell H11 that looks up the sales rep region based on the table in cells E3:F6. I have done a VLOOKUP function but keep ending up with either an #REF or #N/A error. Help!!				Region Code	Region
Date				10	East Coast
Sales Goal	$ 250,000.00			20	Mid West
				30	West Coast
				40	International

2015 Sales Total By Quarter

Sales Rep	Q1	Q2	Q3	Q4	Total	Region Code	Region	Status
Billy	29911	92249	46475	33947	202582	40	#REF!
Randy	32752	30222	43997	93277	200248	40
Mike	36991	54102	63914	42642	197649	20
Jill	50087	25179	64912	68875	209053	20
Lamar	52923	62673	63635	57410	236641	10
Sang	59678	70934	78410	32994	242016	10
Swathi	66385	74270	36165	76548	253368	30
Larry	66936	72838	60479	63324	263577	30
Rick	74507	94178	41391	27235	237311	10
Rich	76889	49266	64225	55410	245790	30
Jill	90515	29238	30973	32145	182871	10
John	97426	43061	26122	83391	250000	10
Greg	98094	47398	80755	40446	266693	40
	$ 833,094.00	$ 745,608.00	$ 701,453.00	$ 707,644.00


Summary
Median Sales
Average Sales Dollar Amount
Total Number of Sales Reps

Answer(0)

Bids(0)

other Questions(10)